﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Store_Keeper/Store_Keeper.master" AutoEventWireup="true" CodeFile="SK_GRNrequest.aspx.cs" Inherits="Store_Keeper_SK_Purchase_Order" %>

<%@ Register Assembly="DevExpress.Web.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxPanel" TagPrefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v10.2.Export, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid.Export" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxPivotGrid.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPivotGrid" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2.Export, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView.Export" tagprefix="dx" %>

<%@ Register assembly="DevExpress.Web.v10.2, Version=10.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxPopupControl" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    
    <script type="text/javascript">
    // <![CDATA[

        function ShowLoginWindow() {
            ASPxPopupControl1.Show();
        }

        function showstock() {

            stock.Show();
        }
        function Addnewstock() {
            addnew.Show();
        }
        function reset() {
            Panel1.Reset();

        }
        function productlist() {
            product.Show();
        }
      
    // ]]> 
    </script>
 
    <style type="text/css">
        .style4
        {
            width: 88px;
        }
        .style8
        {
            width: 166px;
        }
        .style10
        {
            width: 100%;
        }
        .style11
        {
            margin-top: 0px;
        }
        .style13
        {
            width: 19px;
        }
        .style14
        {
            width: 260px;
        }
        .style22
        {
            width: 1151px;
        }
        .style24
        {
            width: 194px;
        }
        .style25
        {
            width: 110px;
        }
        .style27
        {
            margin-left: 0px;
        }
        .style28
        {
            width: 4988px;
        }
        .style29
        {
            width: 115px;
        }
        </style>
   
 
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">

  
    

    <asp:Panel ID="Panel1"  runat="server" ClientInstanceName="Panel1">
        <table width="100%" >
            <tr>
                <td class="style14" >
                    &nbsp;</td>
                <td class="style24" >
                    &nbsp;</td>
                <td class="style25" >
                    &nbsp;</td>
                <td align="left" class="style29">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style14" >
                    &nbsp;</td>
                <td class="style24" >
                    GRN No</td>
                <td class="style25" >
                    <dx:ASPxTextBox ID="ASPxTextBox1" runat="server" ClientIDMode="AutoID" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="200px" 
                        ReadOnly="True">
                        <ValidationSettings>
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
                            </ErrorFrameStyle>
                            <RequiredField ErrorText="Please Enter Order ID" />
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td align="left" class="style29">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style14" >
                    &nbsp;</td>
                <td class="style24" >
                    Supplier Name</td>
                <td class="style25" >
                    <dx:ASPxComboBox ID="DropDownList1" runat="server" ClientIDMode="AutoID"  
                        DropDownStyle="DropDown" IncrementalFilteringMode="StartsWith"
               
                    TextField="Sup_Name" TextFormatString="{0}"  ValueType="System.String"
                            ValueField="Sup_ID" 
                        CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                        DataSourceID="SqlDataSource1" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" Width="200px" 
                        >
                        <LoadingPanelImage Url="~/App_Themes/BlackGlass/Editors/Loading.gif">
                        </LoadingPanelImage>
                        <ButtonStyle Width="11px">
                        </ButtonStyle>
                        <ValidationSettings ErrorText="Error has occurred">
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
                            </ErrorFrameStyle>
                        </ValidationSettings>
                    </dx:ASPxComboBox>
                </td>
                <td align="left" class="style29">
                   
                </td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style14" >
                    &nbsp;</td>
                <td class="style24" >
                    Supplier Bill No</td>
                <td class="style25" >
                    <dx:ASPxTextBox ID="ASPxTextBox3" runat="server" Width="200px" 
                        DisplayFormatString="g">
                        <MaskSettings ErrorText="Invalid Bill No" />
                        <ValidationSettings>
                            <RegularExpression ErrorText="" />
                            <RequiredField ErrorText="Plese Enter Bill No:" IsRequired="True" />
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td align="left" class="style29">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style14" >
                    </td>
                <td class="style24" >
                    Received Date</td>
                <td class="style25" >
                    <dx:ASPxDateEdit ID="ASPxDateEdit2" runat="server" Width="200px" 
                        ClientIDMode="AutoID" CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" 
                        CssPostfix="BlackGlass" 
                        SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css">
                        <CalendarProperties>
                            <HeaderStyle Spacing="1px" />
                            <FooterStyle Spacing="4px" />
                        </CalendarProperties>
                        <ValidationSettings>
                            <ErrorFrameStyle ImageSpacing="4px">
                                <ErrorTextPaddings PaddingLeft="4px" />
                            </ErrorFrameStyle>
                            <RequiredField ErrorText="Please Enter Date" IsRequired="True" />
                        </ValidationSettings>
                    </dx:ASPxDateEdit>
                </td>
                <td align="left" class="style29" >
                    &nbsp;</td>
                <td >
                    </td>
            </tr>
            <tr>
                <td class="style14" >
                    &nbsp;</td>
                <td class="style24" >
                    Book GRN No:</td>
                <td class="style25">
                    <dx:ASPxTextBox ID="ASPxTextBox4" runat="server" Width="200px">
                        <ValidationSettings>
                            <RequiredField ErrorText="Plese Enter Book GRN No:" IsRequired="True" />
                        </ValidationSettings>
                    </dx:ASPxTextBox>
                </td>
                <td align="left" class="style29">
                    &nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="style14">
                    
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                        ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                        SelectCommand="SELECT [Sup_ID], [Sup_Name] FROM [Tbl_Supplier]">
                    </asp:SqlDataSource>
                </td>
                <td align="right" class="style24">
                    <dx:ASPxButton ID="stockbutton" runat="server" AutoPostBack="False" 
                        ClientIDMode="AutoID" CssFilePath="~/App_Themes/Youthful/{0}/styles.css" 
                        CssPostfix="Youthful" SpriteCssFilePath="~/App_Themes/Youthful/{0}/sprite.css" 
                        style="margin: 16px auto;" Text="Add New Product" Width="125px">
                        <ClientSideEvents Click="function(s, e) { showstock(); }" />
                    </dx:ASPxButton>
                </td>
                <td align="left" class="style25">
                    <dx:ASPxButton ID="stockbutton0" runat="server" AutoPostBack="False" 
                        ClientIDMode="AutoID" CssFilePath="~/App_Themes/Youthful/{0}/styles.css" 
                        CssPostfix="Youthful" SpriteCssFilePath="~/App_Themes/Youthful/{0}/sprite.css" 
                        style="margin: 16px auto;" Text="Add Existing Product Stock" Width="125px" 
                        onclick="stockbutton0_Click">
                        <ClientSideEvents Click="function(s, e) { Addnewstock(); }" />
                    </dx:ASPxButton>
                </td>
                <td align="left" class="style29">
                    <dx:ASPxButton ID="productlist" runat="server" AutoPostBack="False" 
                        ClientIDMode="AutoID" CssFilePath="~/App_Themes/Youthful/{0}/styles.css" 
                        CssPostfix="Youthful" SpriteCssFilePath="~/App_Themes/Youthful/{0}/sprite.css" 
                        style="margin: 16px auto;" Text="Product Detail" Width="125px" 
                        BackColor="#99CCFF">
                        <ClientSideEvents Click="function(s, e) { productlist(); }" />
                    </dx:ASPxButton>
                </td>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
    </asp:Panel>



    



    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
        <ContentTemplate>
            <asp:ScriptManager ID="ScriptManager1" runat="server">
            </asp:ScriptManager>
            <dx:ASPxImage ID="ASPxImage1" runat="server" Height="18px" 
                ImageUrl="~/images/green-check-mark-clip-art.jpg" Visible="False">
            </dx:ASPxImage>
            <dx:ASPxLabel ID="ASPxLabel2" runat="server" ClientIDMode="AutoID" 
                CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                Font-Bold="True" Font-Names="Tahoma" Font-Size="Small" ForeColor="#009933" 
                Visible="False">
            </dx:ASPxLabel>
            
            <asp:GridView ID="Gridview1" runat="server" AutoGenerateColumns="False" 
                BackColor="#CCCCCC" BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" 
                CellPadding="4" CellSpacing="2" ForeColor="Black" 
              
              ShowFooter="True" 
                Width="100%" onrowcommand="Gridview1_RowCommand1" 
                onrowdeleting="Gridview1_RowDeleting">
                <Columns>
                
                    
                    <asp:TemplateField HeaderText="Item">
                        <ItemTemplate>
                            <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True"  ClientIDMode='Static' 
                                DataSourceID="SqlDataSource1" DataTextField="Pro_Name" DataValueField="Pro_ID"  Width="200px"
                                onselectedindexchanged="DropDownList3_SelectedIndexChanged1">
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                                SelectCommand="SELECT DISTINCT [Pro_ID], [Pro_Name] FROM [Tbl_Product] order by Pro_Name 
                                ASC">
                            </asp:SqlDataSource>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Stock Code">
                        <ItemTemplate>
                            <asp:DropDownList ID="DropDownList4" runat="server" AutoPostBack="True" 
                                DataSourceID="SqlDataSource2" DataTextField="Sto_ID" DataValueField="Sto_ID" Width="50px" 
                                onselectedindexchanged="DropDownList4_SelectedIndexChanged1">
                            </asp:DropDownList>
                            <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                                SelectCommand="SELECT [Sto_ID] FROM [Tbl_Stock] WHERE ([Pro_ID] = @Pro_ID)">
                                <SelectParameters>
                                    <asp:ControlParameter ControlID="DropDownList3" Name="Pro_ID" 
                                        PropertyName="Text" Type="String" />
                                </SelectParameters>
                            </asp:SqlDataSource>
                        </ItemTemplate>
                         </asp:TemplateField>
                       <asp:TemplateField HeaderText="Product ID">
                        <ItemTemplate>
                            <asp:TextBox ID="TextBox7" Width="50px" runat="server" ReadOnly="true" BackColor="#CED4DF" ForeColor="Black"></asp:TextBox>
                        </ItemTemplate>
                        
                    </asp:TemplateField>

                 
                    <asp:TemplateField HeaderText="Description">
                        <ItemTemplate>
                            <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
                        </ItemTemplate>
                        </asp:TemplateField>
                         <asp:TemplateField HeaderText="Brand ">
                        <ItemTemplate>
                            <asp:TextBox ID="TextBox8" runat="server" ReadOnly="true" BackColor="#CED4DF" ForeColor="Black"></asp:TextBox>
                        </ItemTemplate>
                        </asp:TemplateField>
                         
                    <asp:TemplateField HeaderText="Unit Cost">
                        <ItemTemplate>
                            <asp:TextBox ID="TextBox3" runat="server" BackColor="#CED4DF" ForeColor="Black" 
                                ReadOnly="True" Width="50px"></asp:TextBox>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Unit Selling Price">
                        <ItemTemplate>
                            <asp:TextBox ID="TextBox6" runat="server" BackColor="#CED4DF" ForeColor="Black" 
                                ReadOnly="True" Width="70px"></asp:TextBox>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Quantity">
                        <ItemTemplate>
                             <asp:TextBox ID="TextBox4" runat="server" AutoPostBack="True" Width="50px" 
                                ontextchanged="TextBox4_TextChanged"  ></asp:TextBox>

                        </ItemTemplate>
                       
                        
                    </asp:TemplateField>
                    <asp:TemplateField HeaderText="Line Total">
                        <ItemTemplate> 
   
                            <asp:TextBox ID="TextBox5" runat="server" BackColor="#CED4DF" ></asp:TextBox>
                        </ItemTemplate>
                        <FooterStyle HorizontalAlign="Right" />
                        <FooterTemplate>
                            <asp:Button ID="ButtonAdd" runat="server" onclick="ButtonAdd_Click1" 
                                Text="Add New Row" />
                        </FooterTemplate>
                    </asp:TemplateField>
                    <asp:CommandField ShowDeleteButton="True" />
                </Columns>
                <FooterStyle BackColor="#CCCCCC" />
                <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
                <RowStyle BackColor="White" />
                <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
                <SortedAscendingCellStyle BackColor="#F1F1F1" />
                <SortedAscendingHeaderStyle BackColor="#808080" />
                <SortedDescendingCellStyle BackColor="#CAC9C9" />
                <SortedDescendingHeaderStyle BackColor="#383838" />
            </asp:GridView>

            <dx:ASPxLabel ID="ASPxLabel3" runat="server" ForeColor="Red" Font-Bold="True">
            </dx:ASPxLabel>
            <br />
            <table class="style10">
                <tr>
                    <td class="style28">
                        &nbsp;</td>
                    <td class="style22" align="right">
                        <dx:ASPxLabel ID="ASPxLabel1" runat="server" ClientIDMode="AutoID" 
                            CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                            Font-Bold="True" Font-Size="Medium" ForeColor="#0000CC" Text="Total">
                        </dx:ASPxLabel>
                    </td>
                    <td>
                         <dx:ASPxTextBox ID="ASPxTextBox2" runat="server" 
                    Width="150px" BackColor="#CED4DF" ReadOnly="True" CssClass="style27" >
                    <ValidationSettings>
                        <RequiredField ErrorText="Please Enter Order Details" IsRequired="True" />
                    </ValidationSettings>
                </dx:ASPxTextBox></td>
                    <td>
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="style28">
                        &nbsp;</td>
                    <td class="style22">
                        &nbsp;</td>
                    <td>
                        <dx:ASPxButton ID="ASPxButton1" runat="server" ClientIDMode="AutoID" 
                            CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                            Height="27px" onclick="ASPxButton1_Click" 
                            SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                            Text="Record the Order" Width="137px">
                        </dx:ASPxButton>
                    </td>
                    <td>
                        &nbsp;</td>
                </tr>
            </table>
        </ContentTemplate>
  
  </asp:UpdatePanel>


    



    <br />
    


    <table width="100%" >
        <tr>
            <td>
                &nbsp;</td>
            <td class="style13" align="right">
                
                &nbsp;</td>
            <td class="style8">
                &nbsp;</td>
            <td>

                &nbsp;</td>
        </tr>
        <tr>
            <td>
                
            </td>
            <td class="style13" align="right">

                <dx:ASPxPopupControl ID="addnew" runat="server" CloseAction="CloseButton" Modal="True"
        PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="WindowCenter" ClientInstanceName="addnew"
        HeaderText="Add New Stock" AllowDragging="True" EnableAnimation="False" 
                     EnableViewState="False" Width="846px" ClientIDMode="AutoID" 
                     CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                     Height="500px" SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                    ContentUrl="~/Store_Keeper/Addnewstock.aspx" CssClass="style11">
       
                    <LoadingPanelImage Url="~/App_Themes/BlackGlass/Web/Loading.gif">
                    </LoadingPanelImage>
                    <ContentStyle HorizontalAlign="Left" VerticalAlign="Top">
                    </ContentStyle>
                    <HeaderStyle>
                    <Paddings PaddingBottom="6px" PaddingLeft="15px" PaddingRight="6px" 
                        PaddingTop="3px" />
<Paddings PaddingLeft="15px" PaddingTop="3px" PaddingRight="6px" PaddingBottom="6px"></Paddings>
                    </HeaderStyle>
                    <ContentCollection>
<dx:PopupControlContentControl ID="PopupControlContentControl1" runat="server" SupportsDisabledAttribute="True">
    <dx:ASPxPanel ID="ASPxPanel2" runat="server" Width="100%">
   
        <PanelCollection>
<dx:PanelContent ID="PanelContent1" runat="server" SupportsDisabledAttribute="True">
            </dx:PanelContent>
</PanelCollection>
   
    </dx:ASPxPanel>
    
                        </dx:PopupControlContentControl>
</ContentCollection>
                </dx:ASPxPopupControl>

                <dx:ASPxPopupControl ID="stock" runat="server" CloseAction="CloseButton" Modal="True"
        PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="WindowCenter" ClientInstanceName="stock"
        HeaderText="Add New Stock" AllowDragging="True" EnableAnimation="False" 
                     EnableViewState="False" Width="846px" ClientIDMode="AutoID" 
                     CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                     Height="550px" SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                    ContentUrl="~/Store_Keeper/Addnewproduct.aspx">
       
                    <LoadingPanelImage Url="~/App_Themes/BlackGlass/Web/Loading.gif">
                    </LoadingPanelImage>
                    <ContentStyle HorizontalAlign="Left" VerticalAlign="Top">
                    </ContentStyle>
                    <HeaderStyle>
                    <Paddings PaddingBottom="6px" PaddingLeft="15px" PaddingRight="6px" 
                        PaddingTop="3px" />
<Paddings PaddingLeft="15px" PaddingTop="3px" PaddingRight="6px" PaddingBottom="6px"></Paddings>
                    </HeaderStyle>
                    <ContentCollection>
<dx:PopupControlContentControl ID="PopupControlContentControl2" runat="server" SupportsDisabledAttribute="True">
    
    
                        </dx:PopupControlContentControl>
</ContentCollection>
                </dx:ASPxPopupControl>

            </td>
            <td class="style8">
                &nbsp;</td>
            <td>

                &nbsp;</td>
        </tr>
        <tr>
            <td>
                
                &nbsp;</td>
            <td class="style13" align="right">

       <dx:ASPxPopupControl ID="product" runat="server" CloseAction="CloseButton" Modal="True"
        PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="WindowCenter" ClientInstanceName="product"
        HeaderText="Product Details" AllowDragging="True" EnableAnimation="False" 
                     EnableViewState="False" Width="846px" ClientIDMode="AutoID" 
                     CssFilePath="~/App_Themes/BlackGlass/{0}/styles.css" CssPostfix="BlackGlass" 
                     Height="550px" SpriteCssFilePath="~/App_Themes/BlackGlass/{0}/sprite.css" 
                    ContentUrl="~/Store_Keeper/ProductDetails.aspx">
       
                    <LoadingPanelImage Url="~/App_Themes/BlackGlass/Web/Loading.gif">
                    </LoadingPanelImage>
                    <ContentStyle HorizontalAlign="Left" VerticalAlign="Top">
                    </ContentStyle>
                    <HeaderStyle>
                    <Paddings PaddingBottom="6px" PaddingLeft="15px" PaddingRight="6px" 
                        PaddingTop="3px" />
<Paddings PaddingLeft="15px" PaddingTop="3px" PaddingRight="6px" PaddingBottom="6px"></Paddings>
                    </HeaderStyle>
                    <ContentCollection>
<dx:PopupControlContentControl ID="PopupControlContentControl3" runat="server" SupportsDisabledAttribute="True">
    
    
                        </dx:PopupControlContentControl>
</ContentCollection>
                </dx:ASPxPopupControl>

            </td>
            <td class="style8">
                &nbsp;</td>
            <td>

                &nbsp;</td>
        </tr>
        </table> 
      


    <table width="100%" >
        <tr>
            <td class="style4">
    


                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td class="style4">
    


                &nbsp;</td>
            <td>
                <asp:SqlDataSource ID="SqlDataSource12" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BestlifeDB_tempConnectionString1 %>" 
                    DeleteCommand="DELETE FROM [Tbl_Stock] WHERE [Sto_ID] = @Sto_ID AND [Pro_Name] = @Pro_Name AND [Pro_ID] = @Pro_ID" 
                    InsertCommand="INSERT INTO [Tbl_Stock] ([Pro_Name], [Code], [Qty_in_stock], [Re_Order_Level], [Re_Order_qty], [User_Create], [Date_Create], [Last_Modify], [Pro_ID]) VALUES (@Pro_Name, @Code, @Qty_in_stock, @Re_Order_Level, @Re_Order_qty, @User_Create, @Date_Create, @Last_Modify, @Pro_ID)" 
                    ProviderName="<%$ ConnectionStrings:BestlifeDB_tempConnectionString1.ProviderName %>" 
                    SelectCommand="SELECT [Sto_ID], [Pro_Name], [Code], [Qty_in_stock], [Re_Order_Level], [Re_Order_qty], [User_Create], [Date_Create], [Last_Modify], [Key_Timestamp], [Pro_ID] FROM [Tbl_Stock]" 
                    UpdateCommand="UPDATE [Tbl_Stock] SET [Code] = @Code, [Qty_in_stock] = @Qty_in_stock, [Re_Order_Level] = @Re_Order_Level, [Re_Order_qty] = @Re_Order_qty, [User_Create] = @User_Create, [Date_Create] = @Date_Create, [Last_Modify] = @Last_Modify WHERE [Sto_ID] = @Sto_ID AND [Pro_Name] = @Pro_Name AND [Pro_ID] = @Pro_ID">
                    <DeleteParameters>
                        <asp:Parameter Name="Sto_ID" Type="Int32" />
                        <asp:Parameter Name="Pro_Name" Type="String" />
                        <asp:Parameter Name="Pro_ID" Type="String" />
                    </DeleteParameters>
                    <InsertParameters>
                        <asp:Parameter Name="Pro_Name" Type="String" />
                        <asp:Parameter Name="Code" Type="String" />
                        <asp:Parameter Name="Qty_in_stock" Type="Decimal" />
                        <asp:Parameter Name="Re_Order_Level" Type="Decimal" />
                        <asp:Parameter Name="Re_Order_qty" Type="Decimal" />
                        <asp:Parameter Name="User_Create" Type="String" />
                        <asp:Parameter Name="Date_Create" Type="DateTime" />
                        <asp:Parameter Name="Last_Modify" Type="DateTime" />
                        <asp:Parameter Name="Pro_ID" Type="String" />
                    </InsertParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="Code" Type="String" />
                        <asp:Parameter Name="Qty_in_stock" Type="Decimal" />
                        <asp:Parameter Name="Re_Order_Level" Type="Decimal" />
                        <asp:Parameter Name="Re_Order_qty" Type="Decimal" />
                        <asp:Parameter Name="User_Create" Type="String" />
                        <asp:Parameter Name="Date_Create" Type="DateTime" />
                        <asp:Parameter Name="Last_Modify" Type="DateTime" />
                        <asp:Parameter Name="Sto_ID" Type="Int32" />
                        <asp:Parameter Name="Pro_Name" Type="String" />
                        <asp:Parameter Name="Pro_ID" Type="String" />
                    </UpdateParameters>
                </asp:SqlDataSource>
       <asp:SqlDataSource runat="server" 
                                                ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
                                                SelectCommand="SELECT [Pro_ID], [Pro_Name] FROM [Tbl_Product]" 
                                                ID="SqlDataSource7"></asp:SqlDataSource>


     <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
        ConnectionString="<%$ ConnectionStrings:BestlifeDBConnectionString %>" 
        InsertCommand="INSERT INTO Tbl_GRNrequest(Pro_Name, Pur_Price, Description) VALUES (,,,)" 
       
        >
         <InsertParameters>
             <asp:Parameter Name="newparameter" />
             <asp:Parameter Name="newparameter" />
             <asp:Parameter Name="newparameter" />
             <asp:Parameter Name="newparameter" />
         </InsertParameters>
    
    
    </asp:SqlDataSource>

    
            </td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
    
    

    <br />
     
    
    </asp:Content>



